<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1"><title id="cq20941">DROP CONVERSION</title><body><p id="sql_command_desc">Removes a conversion.</p><section id="section2"><title>Synopsis</title><codeblock id="sql_command_synopsis">DROP CONVERSION [IF EXISTS] <varname>name</varname> [CASCADE | RESTRICT]</codeblock></section><section id="section3"><title>Description</title><p><codeph>DROP CONVERSION</codeph> removes a previously defined conversion.
To be able to drop a conversion, you must own the conversion. </p></section><section id="section4"><title>Parameters</title><parml><plentry><pt>IF EXISTS</pt><pd>Do not throw an error if the conversion does not exist. A notice
is issued in this case. </pd></plentry><plentry><pt><varname>name</varname></pt><pd>The name of the conversion. The conversion name may be schema-qualified.</pd></plentry><plentry><pt>CASCADE</pt><pt>RESTRICT</pt><pd>These keywords have no effect since there are no dependencies on
conversions.</pd></plentry></parml></section><section id="section5"><title>Examples</title><p>Drop the conversion named <codeph>myname</codeph>: </p><codeblock>DROP CONVERSION myname;</codeblock></section><section id="section6"><title>Compatibility</title>
  <p>There is no <codeph>DROP CONVERSION</codeph> statement in the SQL standard. The standard has
          <codeph>CREATE TRANSLATION</codeph> and <codeph>DROP TRANSLATION</codeph> statements that
        are similar to the Greenplum Database <codeph>CREATE CONVERSION</codeph> and <codeph>DROP
          CONVERSION</codeph> statements.</p></section>
  <section id="section7"><title>See Also</title><p><codeph><xref href="ALTER_CONVERSION.xml#topic1" type="topic" format="dita"/></codeph>,
            <codeph><xref href="CREATE_CONVERSION.xml#topic1" type="topic" format="dita"
        /></codeph></p></section></body></topic>
